package com.sailorj.mapper;

import com.sailorj.entity.TbStudent;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface TbStudentMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(TbStudent record);

    int insertSelective(TbStudent record);

    TbStudent selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(TbStudent record);

    int updateByPrimaryKey(TbStudent record);

    @Select("select * from tb_student where is_delete = 0 limit #{page},#{size}")
    List<TbStudent> selectStudentList(@Param("page") Integer page, @Param("size")Integer size);


    @Select("select count(*) from tb_student")
    Long getTotal();
}